/*******************************************************************************************************

Table A6: Distribution of Petitions from the 40 English Counties: Top 3 Topics

*******************************************************************************************************/


*Set directory path
cd "C:\Users\tsa23\Documents\petitions\replication files"


clear all

*Read in data with topics for the counties
use dta\topics_county_rep

*drop if year<1824 \*reduces the sample to that used in Table A5 */

*drop the reform years
drop if year == 1830 | year==1831 | year==1832 

sort year topics

tabulate topics
contract topics 
gsort -_freq

